Senior Financial Analyst (Bad Debt)
Compensation: $56/Hour W2
Hybrid: Three (3) days onsite each week
Location: Houston, Texas
This role will be responsible for:
• Preparing financial, operational, and business-related analyses related to bad debt and penalty revenue fees
• Data analytics required to decipher trends and perform appropriate reports and analyses
• Monitoring and preparing financial forecasts based on inputs from business owners and historical and expected trends
• Monitoring key data inputs and drivers to ensure financial forecasts and variance analyses are accurate
• Compiling and preparing financial performance metrics, reports and presentations, along with communicating results to key stakeholders
• Identifying reporting and forecasting improvements that can be made to improve performance and reduce manual workload
Essential Duties/Responsibilities:
• Responsible for the timely and accurate production of weekly, monthly and quarterly metrics, reports and analyses on delinquencies, bad debt, and penalty revenues.
• Prepares budgets, forecasts and financial analyses for AR aging, bad debt and penalty revenues.
• Leads the creation, maintenance and update of complex financial models that forecast bad debt, penalty revenue and other operating expenses.
• Requires heavy use of large amounts of data, being able to analyze and understand the data and use it to improve models and provide variance explanations.
• Coordinates with key internal stakeholders to determine appropriate modeling assumptions and structuring for bad debt.
• Clearly communicates and presents analyses to senior management for financial decision making.
• Independently and/or cross-functionally conduct special projects that monitor, report and control risk factors driving bad debt.
• Works with Accounting to record month end accruals for monthly close process.
• Leads the process of gathering, analyzing, preparing, and summarizing recommendations for bad debt optimization and drivers of bad debt, including attrition, pricing, operational processes, etc.
• Creates financial analyses and narrative for quarterly earnings preparation on bad debt.
• Responds to ad hoc reporting requests by leadership.
• Performs all aspects of work with a high degree of effectiveness, efficiency and accuracy.
Minimum Requirements:
• Bachelors degree in math, data analytics, business, finance, accounting, or economics from an accredited college or university required
• Experience building financial models that use trends and multiple inputs to forecast future results
• Minimum of five years of experience in a financially focused or data analysis role
•Must be proficient with Power-Bi
Python, SAS and Analytics
• 2 + years of Proficient Excel experience used to prepare reports and perform data analysis using lookup formulas and pivot tables.
Preferred Qualifications:
• Obtains general knowledge of accounting concepts (income statement, general ledger, accruals, debits and credits)
• Experience with SAP General Ledger systems and/or Hyperion Planning systems is a plus
• Experience with SAS, regression analysis and data analytics is a plus
Additional Knowledge, Skills and Abilities:
• Ability to manage and organize workload in order to meet aggressive deadlines
• Ability to work independently with minimal supervision and produce quality results but can also work effectively in a team-oriented environment
• Ability to simplify and improve processes
• Ability to adapt effectively to new and changing requirements
• Obtains strong analytical and problem-solving skills and is detail oriented
• Excels in quickly conceptualizing and assimilating data to make decisions and take appropriate action
• Ability to effectively communicate to a wide range of audiences in both written and oral form